# -*- coding:utf-8 -*-
import xlrd

def read_excel_data():
    f_name = 'students.xlsx'
    data = xlrd.open_workbook(f_name)
    table = data.sheet_by_name('Sheet1')
    row = table.nrows  # 行数
    col = table.ncols
    x_list = []
    key = table.row_values(0)
    j = 1  # 从第二行读取
    for i in range(row-1):
        x_dict = {}
        values = table.row_values(j)
        for x in range(col):
           x_dict[key[x]] = values[x]
        j = j + 1
        x_list.append(x_dict)
    print(x_list)

if __name__ == "__main__":
    read_excel_data()